/*
 Navicat Premium Data Transfer

 Source Server         : dev
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : rm-uf6841b0nfhl6l9c2go.mysql.rds.aliyuncs.com:3306
 Source Schema         : schedule_job

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 06/11/2021 22:36:14
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for cadre_appoint_info
-- ----------------------------
DROP TABLE IF EXISTS `cadre_appoint_info`;
CREATE TABLE `cadre_appoint_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '最后修改人',
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除标识 默认0, 0 否 1 是',
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '姓名',
  `birth_city` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '出生地',
  `gender` tinyint(4) DEFAULT '0' COMMENT '性别,默认值0,0未知,1男性,2女性',
  `resume` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '简历',
  `family_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '民族',
  `native_place` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '籍贯',
  `join_party_time` datetime DEFAULT NULL COMMENT '入党时间',
  `in_work_time` datetime DEFAULT NULL COMMENT '参加工作时间',
  `healthy_status` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '健康状态',
  `major_ skill` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '专业技能',
  `major_ know` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '熟悉专业',
  `qualification` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '全日制学历',
  `graduation_school` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '毕业学校',
  `qualification_job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '在职教育',
  `graduation_school_job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '在职教育毕业院校',
  `current_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '当前职务',
  `proposed_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拟任职务',
  `deposable_position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '拟免职务',
  `rewards` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '奖惩情况',
  `annual_assessment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '年度考核结果',
  `appoint_reason` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '任命理由',
  `report_unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '呈报单位',
  `approve_opinion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '审批机关意见',
  `administration_office_opinion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '行政机关意见',
  `administration_approve_time` datetime DEFAULT NULL COMMENT '行政机关审核时间',
  `approve_time` datetime DEFAULT NULL COMMENT '审批机关审核时间',
  `photo` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '照片',
  `birthday` varchar(100) DEFAULT NULL COMMENT '出生年月日',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='干部任免审批信息表';


-- ----------------------------
-- Table structure for cadre_dept
-- ----------------------------
DROP TABLE IF EXISTS `cadre_dept`;
CREATE TABLE `cadre_dept` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `cadre_id` bigint(20) unsigned DEFAULT NULL COMMENT '干部主键',
  `dept_id` bigint(20) unsigned DEFAULT NULL COMMENT '部门主键',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`cadre_id`),
  KEY `idx_dept_id` (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='干部与部门关系表 ';



DROP TABLE IF EXISTS `cadre_relations_info`;
CREATE TABLE `cadre_relations_info` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '最后修改人',
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除标识 默认0, 0 否 1 是',
  `cadre_appoint_id` bigint(20) DEFAULT NULL COMMENT '干部审批信息ID',
  `appellation` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '称谓',
  `name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '姓名',
  `age` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '年龄/出生年月',
  `political_climate` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '政治面貌',
  `work_unit` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '工作单位',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='干部社会关系信息表';


-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `created_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
  `created_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_by` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '最后修改人',
  `updated_date` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后修改时间',
  `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否删除标识 默认0, 0:否 1:是',
  `parent_id` bigint(20) unsigned NOT NULL DEFAULT '0' COMMENT '父级id,无父部门:0',
  `dept_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL COMMENT '部门名称',
  `dept_hiding` tinyint(4) NOT NULL DEFAULT '0' COMMENT '是否隐藏部门，1:表示隐藏，0:表示显示',
  `dept_code` bigint(20) DEFAULT NULL COMMENT '统一机构编码',
  `sort` int(11) DEFAULT NULL COMMENT '当前部门在父部门下的所有子部门中的排序值',
  `level` tinyint(4) DEFAULT '0' COMMENT '机构级别',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=DYNAMIC COMMENT='部门表';

-- ----------------------------
-- Records of department
-- ----------------------------
BEGIN;
INSERT INTO `department` VALUES (1, NULL, '2021-10-15 08:19:47', NULL, '2021-10-15 08:52:59', 0, 0, '宝清县委', 0, 1, NULL, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
